2016-07-26 - 27716 - Service Request - Missing Customer from AR120 Japan #CrystalReportsSupport
Service Request
27716 - Missing Customer from AR120 (Japan)
Problem Summary
Need to investigate the Missing Customer from AR120 Japan.
Admin Info
Purpose
|
Need to investigate the Missing Customer from AR120 Japan
|
Requested by
|
Daniel Brennan
|
Issue Date
|
07-26-2016
|
Resolved by
|
Venkateswara Reddy
|
Resolved Date
|
08-12-2012
|
Document Status
|
Complete
|
Detailed Problem Description
Email from Daniel Brennan on 07/26/2016:
It looks like there is a bad join in infoset ZSD_CREDIT_OVERVIEW which is causing records to be missing from "Credit Information for Control Area - AR120". I've included the tables/fields used in the report so that you can discuss with your technical resources on whether there is any source in BW that we should be sourcing from, instead of continuing to use an infoset.
Solution Analysis and Recommendations
1. Need to investigate if all the fields are available or not in BW source.
2. Need to check the links between the tables in the infoset.
3. Need to change the join type to left outer join between the tables S066 and S067 in infoset.
Resolution
1. Checked all the fields that are available in BW source.
2. Checked the links between the tables in the infoset.
3. Need to change the join type to left outer join between the tables S066 and S067 in infoset.
Release Information
None